package com.bpc.cs.constant;

public class DBConstant {

	/**
	 *  Table name in database
	 */
	public static final String TBL_SCORING_SCHEME = "\"SCORING_SCHEME\"";
	public static final String TBL_SCORING_FACTOR = "\"SCORING_FACTOR\"";
	public static final String TBL_SCORING_RULE = "\"SCORING_RULE\"";
	public static final String TBL_SCORING_FACTOR_CHOICE = "\"SCORING_FACTOR_CHOICE\"";

	/**
	 *  Column name in table
	 */
	// Table SCORING_SCHEME
	public static final String COL_SS_ID = "\"SS_ID\"";
	public static final String COL_SS_NAME = "\"SS_NAME\"";

	// Table SCORING_FACTOR
	public static final String COL_SF_ID = "\"SF_ID\"";
	public static final String COL_SF_NAME = "\"SF_NAME\"";

	// Table SCORING_RULE
	public static final String COL_SR_ID = "\"SR_ID\"";
	public static final String COL_SR_SS_ID = "\"SR_SS_ID\"";
	public static final String COL_SR_SF_ID = "\"SR_SF_ID\"";
	public static final String COL_SR_WEIGHT = "\"SR_WEIGHT\"";

	// Table SCORING_FACTOR_SCHOICE
	public static final String COL_SFC_ID = "\"SFC_ID\"";
	public static final String COL_SFC_SR_ID = "\"SFC_SR_ID\"";
	public static final String COL_SFC_FACTOR_CHOICE = "\"SFC_FACTOR_CHOICE\"";
	public static final String COL_SFC_SCORE = "\"SFC_SCORE\"";
}
